<?php
  include( "./DFHead" );
  $sqlstr = "SELECT * FROM venue";
  $venres = mysql_query( $sqlstr, $db )
    or die ( 'Failed venue query in dfcon.php ' . mysql_error() );
  $vname = mysql_result( $venres, 0, 'vname' );
  $vphone = mysql_result( $venres, 0, 'vphone' );
  $vaddr = mysql_result( $venres, 0, 'vaddr' );
  $vcity = mysql_result( $venres, 0, 'vcity' );
  $vstate = mysql_result( $venres, 0, 'vstate' );

  $sqlstr = "SELECT * FROM dfdata";
  $datres = mysql_query( $sqlstr, $db )
    or die ( 'Failed dfdata query in dfcon.php ' . mysql_error() );
  $year = mysql_result( $datres, 0, 'year' );
  $month = mysql_result( $datres, 0, 'month' );
  $dates = mysql_result( $datres, 0, 'dates' );
  echo "Dates: $dates $month $year<br />";
  $fday = mysql_result( $datres, 0, 'fday' );
  $start = mysql_result( $datres, 0, 'start' );
  $lday = mysql_result( $datres, 0, 'lday' );
  $end = mysql_result( $datres, 0, 'end' );
?>
      <table width="100%" cellpadding="0" cellspacing="0" border="0">
        <tr>
          <td height=10>
            &nbsp;
          </td>
        </tr>
        <tr valign=top>
          <td width=200>
            <?php
              include( "./DFPCP" );
            ?>
            <p>
              &nbsp;
            </p>
          </td>
          <td width=20>
            &nbsp;
          </td>
          <td valign="top" align="left">
            <table border="0" cellspacing="0" cellpadding="10">
              <tr>
                <td>
                  <a href="./index.html">
                    Dragonflight >
                  </a>
                </td>
              </tr>
              <tr>
                <td>
                  <span class="title36">
                    Dragonflight Convention
                  </span>
                </td>
              </tr>
              <tr>
                <td>
                  The Dragonflight Convention started in 1980 and is one of the longest running gaming conventions in the Pacific Northwest. This event gathers together more than 500 players and GMs to play in or run some 300 events spread over three days in August. Here is a list of what we offer:
                  <br />
                  <br />
                  <ul>
                    <li>
                      Board games
                    </li>
                    <li>
                      Role-playing
                    </li>
                    <li>
                      RPGA
                    </li>
                    <li>
                      Miniatures
                    </li>
                    <li>
                      LARP (Live Action Role-playing)  
                    </li>
                    <li>
                      Networked Computer Games
                    </li>
                    <li>
                      Card games
                    </li>
                    <li>
                      Seminars
                    </li>
                    <li>
                      An auction featuring all kinds of gaming collectibles
                    </li>
                    <li>
                      Vendors from around the Seattle area, including Game Stores,
                      Game Companies, Artists, Online Magazines, and other resources
                      that are related to gaming.
                    </li>
                  </ul>
                  Most of our events are geared toward adult and young adult players,
                  although a growing number each year are designed just for younger
                  players (ages 8 and up).
                  <br />
                  <br />
                </td>
              </tr>
              <tr>
                <td>
                  <span class="title36">
                    Registration
                  </span>
                </td>
              </tr>
              <tr>
                <td>
                  Registration is online or at the door.  Admission rates are on
                  the sidebar of
                  <a href="./registration.php">
                    this page.
                  </a>
                  You can register for the convention at our
                  <a href="./reg/default.asp">
                    Registration web site.
                  </a>
                  <br />
                  <br />
                </td>
              </tr>
              <tr>
                <td>
                  <span class="title36">
                    Event Submissions
                  </span>
                </td>
              </tr>
              <tr>
                <td>
                  Calling All GMs, DMs, Judges and Event Presenters! Volunteers
                  are needed to present events at Dragonflight. This convention
                  is for gamers and is run by gamers. We're all volunteers. Want
                  to volunteer to run your favorite game? The earlier you submit
                  your event the more likely it will run in the time slot you
                  choose.
                  <br />
                  <br />
                  <a href="./notthere.php">
                    GM Guide
                  </a>
                  <br />
                  <br />
                  Submit events at our
                  <a href="./reg/">
                    Registration Web Site
                  </a>
                  (separate login). 
                  </a>
                  <br />
                  <br />
                </td>
              </tr>
              <tr>
                <td>
                  <span class="title36">
                    Dealer/Exhibitor Special
                  </span>
                </td>
              </tr>
              <tr>
                <td>
                  We have rearranged our dealer space this year to make it easier
                  for players to stop by between events and to improve security
                  at night. You may also buy advertisement space in our brochures,
                  donate prizes and offer other Convention support. Please
                  contact our
                  <a href="./contacts.php">
                    Dealer Liaison
                  </a>
                  for more information or review
                  the Dealer/Exhibitor FAQ's:
                  <a href="./notthere.php">
                    Dealer Guide
                  </a>
                  <br />
                  <br />
                </td>
              </tr>
            </table>
          </td>
          <td width='200' bgcolor='#EEEEEE'>
            <table cellpadding='4'>
              <tr>
                <td>
                  <span class='title24'>
                    At A Glance
                  </span>
                  <font size='3'>
                  <br />
                  <br />
                  <b>
                  When
                  </b>
                  <br />
                  <?php
                    echo "$start $fday through $end $lday<br />$dates $month $year";
                  ?>
                  <br />
                  <br />
                  <b>
                  Where
                  </b>
                  <br />
                  <?php
                    echo "$vname<br />$vaddr<br />$vcity, $vstate";
                  ?>
                  <br />
                  <br />
                  <b>
                  Registration Hours
                  </b>
                  <br />
                  <?php
                    echo "$fday - $start to 9 pm<br />30 minutes earlier for pre-registered";
                  ?>
                  <br />
                  Saturday, 8 am to 9 pm
                  <br />
                  Sunday, 8 am to 6 pm
                  <br />
                  <br />
                  <b>
                  Lodging
                  </b>
                  <br />
                  <?php
                    echo "<a href='./venue.php'>$vname</a><br />Call $vphone<br />Mention 'Dragonflight' for convention rate.";
                  ?>
                  <br />
                  </font>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </CENTER>
    <?php
      ob_end_flush();
      include( "./DFTail" );
    ?>
  </body>
</html>
